<?php
    $xtpl_content   = new XTemplate("view/content.htm");
    
    $sql    = "SELECT * FROM account WHERE username='admin'";
    $result = mysql_query($sql);
    $row    = mysql_fetch_array($result);
    
    $sqldate    = strtotime($row['birthday']);
    $birthday   = date('d-m-Y', $sqldate);
    
    $xtpl_content   -> assign('fullname', $row['fullname']);
    $xtpl_content   -> assign('birthday', $birthday);
    $xtpl_content   -> assign('phone', $row['phone']);
    $xtpl_content   -> assign('email', $row['email']); 
    
    $xtpl_content   -> parse("CONTENT");
    $content        = $xtpl_content -> text("CONTENT");
?>